if object_id (N'[dbo].[add_new_department]', N'P') IS NOT NULL
    drop procedure [dbo].[add_new_department];
go

/********************************************************
creator: Zoran Arsovski
created: 03.11.2007.
last modifier: unknown
last modified: unknown

description: Procedurata dodava nov red vo tabela Department
						 dokolku istiot ne postoi.
						 Vo sprotivno vrsi update na podatocite.
test: add_new_person '1203980450666', 'Tester', 'Tester', 'test', 'test123'
*********************************************************/

create procedure [dbo].[add_new_department] 
(
	-- Input Parametars
	@department_id bigint,
	@description nvarchar(70),
	@visit_start datetime = null,
	@visit_end datetime = null
) as
begin

		insert into department
		(department_id, description, visit_start, visit_end)
		values
		(@department_id, @description, @visit_start, @visit_end)

end
go		